//Figure 1(a)

use "\\EAD02\EAD_UQUAM\Localization\NAICS6_panel\cdf_rhs.dta", clear
gen rdshr=rd/vsm

destring naics, replace
collapse nprdprd rdshr rd vsm av_klems l_idist_n3 l_odist_n3 l_idist_n7 l_odist_n7 l_idist_n10 l_odist_n10 import_tot m_othershr m_asiashr m_oecdshr m_naftashr m_hwshr m_usshr export_tot x_othershr x_asiashr x_oecdshr x_naftashr x_hwshr x_usshr naics, by(year)

twoway (line av_klems year, lcolor(black))
save "\\EAD02\EAD_UQUAM\Localization\results\graphs\transport_year.gph", replace
